<%@ Page Language="C#" AutoEventWireup="true" CodeFile="StoredProcedurePage.aspx.cs" Inherits="StoredProcedurePage" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:RecruitVietnamDbConnectionString %>"
            SelectCommand="SPJobPostingsOfRecruiter" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:SessionParameter Name="RecruiterID" SessionField="rcuserid" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
        &nbsp;</div>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
            <Columns>
                <asp:BoundField DataField="RecruiterID" HeaderText="RecruiterID" SortExpression="RecruiterID" />
                <asp:BoundField DataField="JobTitle" HeaderText="JobTitle" SortExpression="JobTitle" />
                <asp:BoundField DataField="ContactPerson" HeaderText="ContactPerson" SortExpression="ContactPerson" />
                <asp:BoundField DataField="ContactTel" HeaderText="ContactTel" SortExpression="ContactTel" />
                <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
                <asp:BoundField DataField="WorkLocation" HeaderText="WorkLocation" SortExpression="WorkLocation" />
            </Columns>
        </asp:GridView>
    </form>
</body>
</html>
